# Using Oracle as a data warehouse

This section describes how to set up Oracle as a data warehouse in a Compose project.

Information note

When loading a huge number of records (i.e. hundreds of millions), the UNDO/REDO/TEMP tablespace on the Oracle database must be large enough to hold the data being loaded.

It contains the following topics:

* [Prerequisites](https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/Data%20Warehouse%20Connection/prerequisites_oracle.htm)
* [Oracle data types](https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/Data%20Warehouse%20Connection/data_types_oracle.htm)
* [Defining the connection parameters](https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/Data%20Warehouse%20Connection/define_connection_parameters_oracle.htm)